{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Brüt","Parametre"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Brüt","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Ay","Brüt Ücret","SGK Devir","SGK MATRAH","SSK İşçi","SSK İşçi İşsizlik","GV Matrahı","Kümülatif GV Matrahı","GV","Damga Vergisi","Net","İşveren Primi","İşveren İşsizlik Primi","Toplam Maliyet"]
["Ocak",5004,{"$f":"IF((IF(A2=\"Ocak\",IFERROR(C1*0,0),IFERROR(C1*1,0)))+B2>SGKTAVAN,(IF(A2=\"Ocak\",IFERROR(C1*0,0),IFERROR(C1*1,0)))+B2-D2,0)","v":0},{"$f":"IF(B2+(IF(A2=\"Ocak\",IFERROR(C1*0,0),IFERROR(C1*1,0)))>SGKTAVAN,SGKTAVAN,B2+(IF(A2=\"Ocak\",IFERROR(C1*0,0),IFERROR(C1*1,0))))","v":5004},{"$f":"D2*14/100","v":700.56},{"$f":"D2*1/100","v":50.04},{"$f":"B2-(E2+F2)","v":4253.3999999999996},0,{"$f":"GV(H2,G2,A2)","v":0},{"$f":"DV(A2,B2)","v":0},{"$f":"B2-(E2+F2+I2+J2)","v":4253.3999999999996},{"$f":"D2*20.5/100","v":1025.82},{"$f":"D2*2/100","v":100.08},{"$f":"B2+L2+M2","v":6129.9}]
["Şubat",5004,0,5004,{"$f":"D3*14/100","v":700.56},{"$f":"D3*1/100","v":50.04},4253.3999999999996,{"$f":"G2+H2","v":4253.3999999999996},{"$f":"GV(H3,G3,A3)","v":0},{"$f":"DV(A3,B3)","v":0},{"$f":"B3-(E3+F3+I3+J3)","v":4253.3999999999996},{"$f":"D3*20.5/100","v":1025.82},100.08,6129.9]
["Mart",5004,0,5004,700.56,50.04,4253.3999999999996,{"$f":"G3+H3","v":8506.7999999999993},0,0,4253.3999999999996,{"$f":"D4*20.5/100","v":1025.82},100.08,6129.9]
["Nisan",5004,0,5004,700.56,50.04,4253.3999999999996,12760.199999999999,0,0,4253.3999999999996,1025.82,100.08,6129.9]
["Mayıs",5004,0,5004,700.56,50.04,4253.3999999999996,17013.599999999999,0,0,4253.3999999999996,1025.82,100.08,6129.9]
["Haziran",5004,0,5004,700.56,50.04,4253.3999999999996,21267,{"$f":"GV(H7,G7,A7)","v":0},0,4253.3999999999996,1025.82,100.08,6129.9]
["Temmuz",6471,0,6471,905.94,64.709999999999994,5500.35,25520.400000000001,2.5000000000545697E-3,0,5500.3474999999999,1326.5550000000001,129.41999999999999,7926.9750000000004]
["Ağustos",6471,0,6471,905.94,64.709999999999994,5500.35,31020.75,0,0,5500.35,1326.5550000000001,129.41999999999999,7926.9750000000004]
["Eylül",6471,0,6471,905.94,64.709999999999994,5500.35,36521.1,2.2737367544323206E-13,0,5500.3499999999995,1326.5550000000001,129.41999999999999,7926.9750000000004]
["Ekim",6471,0,6471,905.94,64.709999999999994,5500.35,42021.45,2.2737367544323206E-13,0,5500.3499999999995,1326.5550000000001,129.41999999999999,7926.9750000000004]
["Kasım",6471,0,6471,905.94,64.709999999999994,5500.35,47521.799999999996,2.2737367544323206E-13,0,5500.3499999999995,1326.5550000000001,129.41999999999999,7926.9750000000004]
["Aralık",6471,0,6471,905.94,64.709999999999994,5500.35,53022.149999999994,2.2737367544323206E-13,0,5500.3499999999995,1326.5550000000001,129.41999999999999,7926.9750000000004]
["Toplam",{"$f":"SUM(B2:B13)","v":68850},null,null,{"$f":"SUM(E2:E13)","v":9639.0000000000018},{"$f":"SUM(F2:F13)","v":688.5},null,58522.499999999993,{"$f":"SUM(I2:I13)","v":2.5000000009640644E-3},0,58522.497499999998,14114.25,1377,84341.250000000015]

{"sheet":"Parametre","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Vergi Dilimler Aralıkları",null,"Vergi Oranı"]
[0,32000,15]
[32000,70000,20]
[70000,250000,27]
[250000,880000,35]
[880000,null,40]
[]
[null,"OCAK 2022","TEMMUZ 2022"]
["Asgari Ücret",5004,6471]
["SGK Tavanı",37530,48532.5]
["Damga Vergisi Matrahı",7.5900000000000004E-3,7.5900000000000004E-3]